﻿using System;
namespace fanli.Model
{
	/// <summary>
	/// 兑换记录实体类：fanli_exchangeRecord 。
	/// </summary>
	[Serializable]
	public class fanli_exchangeRecord
	{
		public fanli_exchangeRecord()
		{}

		#region Model
		private int _id; //id
		private int _giftID; //礼品id
		private int _userID; //用户id
		private DateTime? _exchangeDate; //兑换时间
		private int _status; //兑换状态
		private DateTime? _confirmDate; //确认时间
		private int _adminID; //确认人id


        /// <summary>
		/// id
		/// </summary>
		public int id
		{
			set{ _id=value;}
			get{return _id;}
		}
        /// <summary>
		/// 礼品id
		/// </summary>
		public int giftID
		{
			set{ _giftID=value;}
			get{return _giftID;}
		}
        /// <summary>
		/// 用户id
		/// </summary>
		public int userID
		{
			set{ _userID=value;}
			get{return _userID;}
		}
        /// <summary>
		/// 兑换时间
		/// </summary>
		public DateTime? exchangeDate
		{
			set{ _exchangeDate=value;}
			get{return _exchangeDate;}
		}
        /// <summary>
		/// 兑换状态
		/// </summary>
		public int status
		{
			set{ _status=value;}
			get{return _status;}
		}
        /// <summary>
		/// 确认时间
		/// </summary>
		public DateTime? confirmDate
		{
			set{ _confirmDate=value;}
			get{return _confirmDate;}
		}
        /// <summary>
		/// 确认人id
		/// </summary>
		public int adminID
		{
			set{ _adminID=value;}
			get{return _adminID;}
		}
		#endregion Model

		#region txt document
		/*
兑换记录,exchangeRecord
id,礼品id,用户id,兑换时间,兑换状态,确认时间,确认人id
id,giftID,userID,exchangeDate,status,confirmDate,adminID
i,i,i,d,i,d,i



--------------------------
-- 创建表[兑换记录]开始: 
-- alter table  [fanli_exchangeRecord] add
-- IF EXISTS (SELECT 1 FROM sysobjects WHERE xtype='u' AND name='fanli_exchangeRecord') drop table fanli_exchangeRecord
  CREATE TABLE [fanli_exchangeRecord] (
	 [id] integer IDENTITY (1, 1) PRIMARY KEY NOT NULL ,
	 [giftID] int,
	 [userID] int,
	 [exchangeDate] [datetime],
	 [status] int,
	 [confirmDate] [datetime],
	 [adminID] int
  )

 exec sp_addextendedproperty N'MS_Description',N'兑换记录 ',N'user',N'dbo',N'table',N'fanli_exchangeRecord', NULL, NULL
 exec sp_addextendedproperty N'MS_Description',N'id',N'user',N'dbo',N'table',N'fanli_exchangeRecord',N'column',N'id'
 exec sp_addextendedproperty N'MS_Description',N'礼品id',N'user',N'dbo',N'table',N'fanli_exchangeRecord',N'column',N'giftID'
 exec sp_addextendedproperty N'MS_Description',N'用户id',N'user',N'dbo',N'table',N'fanli_exchangeRecord',N'column',N'userID'
 exec sp_addextendedproperty N'MS_Description',N'兑换时间',N'user',N'dbo',N'table',N'fanli_exchangeRecord',N'column',N'exchangeDate'
 exec sp_addextendedproperty N'MS_Description',N'兑换状态',N'user',N'dbo',N'table',N'fanli_exchangeRecord',N'column',N'status'
 exec sp_addextendedproperty N'MS_Description',N'确认时间',N'user',N'dbo',N'table',N'fanli_exchangeRecord',N'column',N'confirmDate'
 exec sp_addextendedproperty N'MS_Description',N'确认人id',N'user',N'dbo',N'table',N'fanli_exchangeRecord',N'column',N'adminID'

-- 创建表[兑换记录]结束。 
--------------------------

		*/
		#endregion document
	}
}

